<?
require('../configuracion.php');
require('../db.php');

$query  = " SELECT * FROM tbl_CampaniasCRM ";
$query .= " WHERE (id_TipoCorreo = 2) ORDER by dt_FechaEnvio DESC; ";
$resTotal = mssql_query($query);

?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title><?= $instanciaECRM ?></title>
</head>

<body>
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><img src="headerLogoMobile.gif"></td>
  </tr>
  <tr>
    <td><font color="#666666" size="4"><strong>eCRM Mobile</strong></font></td>
  </tr>
  <tr>
    <td valign="bottom"><img src="icPgCEmail.gif"><strong>Campa&ntilde;as E-mail</strong></td>
  </tr>
</table>
<br>
<?
while ($rowTotal = mssql_fetch_object($resTotal)) {

	$nomEmail = $rowTotal->st_NombreCorreo;
	echo "<img src='icArrowGo.gif'>&nbsp;";
	echo "<a href='mob_detalleemail.php?idcampania=".$rowTotal->id_Campania."'>".$nomEmail."</a>&nbsp;(".date('d/m/Y',strtotime($rowTotal->dt_FechaEnvio)).")";
	echo "<br>";

}
?>
<font color="#999999"><?= date("l, d/m/Y H:i:s") ?></font>
<br>
<br>
<img src="icArrowGo.gif">&nbsp;<a href="indexHomeMobile.html">Regresar</a><br>
<br>
</body>
</html>
